Re: Unable to use COPY..FROM with NULL numeric fields

On Tue, 29 Oct 2002 16:34:55 -0800 in message
<E936C9C6709EF340B2B00D779FD59CF703BE2D2D@nowexchange.HANKEYINVESTMENTS.COM>,"Nikh Nath" <nnath@westlakefinancial.com>
wrote:
> Hi,
>
> I am trying to use the following command to import a file into pgsql.
>
>     COPY acct FROM '/home/megasys/acct.dmp.new' USING DELIMITERS
> '\t' WITH NULL AS '\N';
>
> I keep getting this error.
>
> ERROR:  copy: line 1, Bad numeric input format '\N'
>

Try:

    COPY acct FROM '/home/megasys/acct.dmp.new' USING DELIMITERS '\t' WITH NULL AS '\\N';

eric